package com.wanbangee.marksystem.dao;


import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;


@Mapper
public interface MAnswerSheetTemplateDao {
	/**
	 * 将模板表的信息插入客观题
	 */
	void insertIntoMObjectiveAnswerBySelectMAnswerSheetTemplate();
	/**
	 * 将将模板表的信息插入主观题
	 */
	void insertIntoMSubjectiveSetBySelectMAnswerSheetTemplate();
	/**
	 * 通过exam_id和exam_sub_id查询这场模板考试的总分
	 * @param exam_id
	 * @param examSubId
	 * @return
	 */
	Double selectTopicScoreTempTotal(Integer examId,Integer examSubId);
	/**
	 * 查询实际的所有总分之和
	 * @param exam_id
	 * @param examSubId
	 * @return
	 */
	Double selectTopicScoreActalTotal(Integer examId,Integer examSubId);
	
	/**
	 * 查询该考试科目指定题目的分数
	 * @param examId
	 * @param subId
	 * @param topicNo
	 * @return
	 */
	public Double selectTopicScoreByExamIdAndSubIdAndTopicNo(@Param("examId")Integer examId,@Param("subId")Integer subId,@Param("topicNo")String topicNo);
}
